[dbo].[ComponentRegistryCategory]

Property	Value
Row Count	252
Created	10:31:17 AM Tuesday, March 02, 2010
Last Modified	11:40:01 AM Monday, February 20, 2012

Property

Value

Row Count

252

Created

10:31:17 AM Tuesday, March 02, 2010

Last Modified

11:40:01 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Allow Nulls	Default
$Cluster Primary Key PK_ComponentRegistryCategory: ComponentKey\ComponentCategoryKey$	ComponentKey	uniqueidentifier	16		(newid())
$Cluster Primary Key PK_ComponentRegistryCategory: ComponentKey\ComponentCategoryKey$	ComponentCategoryKey	uniqueidentifier	16

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

$Cluster Primary Key PK_ComponentRegistryCategory: ComponentKey\ComponentCategoryKey$

ComponentKey

uniqueidentifier

(newid())

$Cluster Primary Key PK_ComponentRegistryCategory: ComponentKey\ComponentCategoryKey$

ComponentCategoryKey

uniqueidentifier

	Name	Columns	Unique
$Cluster Primary Key PK_ComponentRegistryCategory: ComponentKey\ComponentCategoryKey$	PK_ComponentRegistryCategory	ComponentKey, ComponentCategoryKey

Name

Columns

Unique

$Cluster Primary Key PK_ComponentRegistryCategory: ComponentKey\ComponentCategoryKey$

PK_ComponentRegistryCategory

ComponentKey, ComponentCategoryKey

Name	Columns
FK_ComponentRegistryCategory_ComponentCategoryRef	ComponentCategoryKey->[dbo].[ComponentCategoryRef].[ComponentCategoryKey]
FK_ComponentRegistryCategory_ComponentRegistry	ComponentKey->[dbo].[ComponentRegistry].[ComponentKey]

Name

Columns

FK_ComponentRegistryCategory_ComponentCategoryRef

ComponentCategoryKey->[dbo].[ComponentCategoryRef].[ComponentCategoryKey]

FK_ComponentRegistryCategory_ComponentRegistry

ComponentKey->[dbo].[ComponentRegistry].[ComponentKey]

SQL Script

CREATE TABLE [dbo].[ComponentRegistryCategory]
(
[ComponentKey] [uniqueidentifier] NOT NULL CONSTRAINT [DF_ComponentRegistryCategory_ComponentKey] DEFAULT (newid()),
[ComponentCategoryKey] [uniqueidentifier] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ComponentRegistryCategory] ADD CONSTRAINT [PK_ComponentRegistryCategory] PRIMARY KEY CLUSTERED ([ComponentKey], [ComponentCategoryKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ComponentRegistryCategory] ADD CONSTRAINT [FK_ComponentRegistryCategory_ComponentCategoryRef] FOREIGN KEY ([ComponentCategoryKey]) REFERENCES [dbo].[ComponentCategoryRef] ([ComponentCategoryKey])
GO
ALTER TABLE [dbo].[ComponentRegistryCategory] ADD CONSTRAINT [FK_ComponentRegistryCategory_ComponentRegistry] FOREIGN KEY ([ComponentKey]) REFERENCES [dbo].[ComponentRegistry] ([ComponentKey])
GO